CREATE TABLE [dbo].[ActivitySummaryFail]
(
[ActivitySummaryId] [int] NOT NULL,
[InstrumentId] [int] NULL,
[ActivityDate] [smalldatetime] NULL,
[ActivityType] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TradePrice] [decimal] (22, 10) NOT NULL,
[ExchRatePurch] [decimal] (22, 10) NOT NULL,
[BlotterId] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ActivityNotes] [varchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CreatedDate] [datetime] NOT NULL,
[CreatedBy] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ModifiedDate] [datetime] NOT NULL,
[ModifiedBy] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[OID] [bit] NOT NULL,
[NotionalValModifiedBy] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ParentActivitySummaryId] [int] NULL,
[IsNonBroadlySynd] [bit] NOT NULL,
[PortfolioPurchase] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NBSReason] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
